import datetime
import pandas as pd
import numpy as np

def get_datetime(date_string):
    return datetime.datetime.strptime(date_string, '%Y-%m-%d')

def read_radio_program(excel_filename):
    xl = pd.ExcelFile(excel_filename)
    convert = {1:'News', 2:'Music', 3:'Misc'}

    dfs = dict()
    for sheet in xl.sheet_names:
        sheet_df = xl.parse(sheet)
        sheet_df['Content_string'] = [convert[x] for x in np.array(sheet_df['Content'].astype(int))] # Must be an easier way to convert series to int
    #     sheet_df['Content']
        dfs[sheet] = sheet_df
    return dfs
